ExportOptions Object

Sample Code - ExportOptions Object

The ExportOptions Object provides properties and methods for retrieving information and setting options for exporting your report (that is, export format, destination, etc.). An ExportOptions Object is obtained from the ExportOptions property of the Report Object.

ExportOptions Object Properties

Property Description Read/Write

Application

Returns a reference to the Application Object, that this object is associated with.

Read only

CharFieldDelimiter

Returns/Sets the character used to separate fields in character separated text formats. This character delimits every field in the file.

Read/Write

CharStringDelimiter

Returns/Sets the character used to separate strings in character separated text formats. This character delimits only string fields (numeric, date fields, etc., have no delimiter).

Read/Write

DestinationDLLName

Returns the name of the DLL used to export the report to a specific destination.

Read only

DestinationType

Returns/Sets CRExportDestinationType (see table below) indicating the destination type for the exported report (that is, disk, mail, etc.).

Read/Write


Constant Value


crEDTDiskFile

1


crEDTMailMAPI

2


crEDTMailVIM

3


crEDTMicrosoftExchange

4


crEDTNoDestination

0

Property Description Read/Write

DiskFileName

Returns/Sets the file name if the report is exported to a disk.

Read/Write

ExcelTabHasColumn
Headings

Returns/Sets Boolean value indicating whether when exporting to Excel format, the spreadsheet will be displayed including column headings. By default this property is set to FALSE.

Read/Write

ExchangeDestination
Type

Returns/Sets CRExchangeDestinationType (see table below) indicating the Exchange destination type for reports exported to Exchange folders.

Read/Write


Constant Value


crExchangePostDocMessage

1011


crExchangeFolderType

0

Property Description Read/Write

ExchangeFolderPath

Returns/Sets the path of the Exchange folder for reports exported to Exchange (that is, "PersonalFolders@Inbox").

Read/Write

ExchangePassword

Returns/Sets the password used to access the Exchange folder for reports exported to the 16-bit version of Exchange.

Read/Write

ExchangeProfile

Returns/Sets a user profile for accessing an Exchange folder for reports exported to Exchange.

Read/Write

FormatDLLName

Returns the file name of the DLL corresponding to the export format.

Read only

FormatType

Returns/Sets CRExportFormatType (see table below) indicating the format type for the exported report (that is, text, Excel, etc.).

Read/Write


Constant Value


crEFTCharSeparatedValues

7


crEFTCommaSeparatedValues

5


crEFTCrystalReport

1


crEFTDataInterchange

2


crEFTExcel21

18


crEFTExcel30

19


crEFTExcel40

20


crEFTExcel50

21


crEFTExcel50Tabular

22


crEFTExplorer32Extend

25


crEFTHTML32Standard

24


crEFTLotus123WK3

13


crEFTLotus123WK1

12


crEFTLotus123WKS

11


crEFTNetScape20

26


crEFTNoFormat

0


crEFTODBC

23


crEFTPaginatedText

10


crEFTQuattroPro50

17


crEFTRecordStyle

3


crEFTRichText

4


crEFTTabSeparatedText

9


crEFTTabSeparatedValues

6


crEFTText

8


crEFTWordForDOS

15


crEFTWordForWindows

14


crEFTWordPerfect

16

Property Description Read/Write

HTMLFileName

Returns/set the HTML file name for reports exported to HTML format.

Read/Write

MailBccList

Returns/Sets a Blind Carbon Copy (BCC) list for reports e-mailed to a VIM e-mail account.

Read/Write

MailCcList

Returns/Sets a Carbon Copy (CC) list for reports e-mailed.

Read/Write

MailMessage

Returns/Sets the e-mail message included with e-mailed reports.

Read/Write

MailSubject

Returns/Sets the e-mail subject heading for reports being e-mailed.

Read/Write

MailToList

Returns/Sets the To list for reports being e-mailed.

Read/Write

NumberOfLinesPer
Page

Integer. Gets or sets the number of lines to appear per page option for reports exported to a paginated text format.

Read/Write

ODBCDataSource
Name

Returns/Sets the ODBC data source for reports exported to ODBC.

Read/Write

ODBCDataSourcePassword

Returns/Sets the password used to access an ODBC data source for reports exported to ODBC.

Read/Write

ODBCDataSource
UserID

Returns/Sets the user name used to access an ODBC data source for reports exported to ODBC.

Read/Write

ODBCExportTable
Name

Returns/Sets the database table in the ODBC data source that the report file exported to ODBC will be appended to. You can also create a new table using this property.

Read/Write

Parent

Reference to the Parent object (Report Object).

Read only

Report

Reference to Report Object.

Read only

UseReportDateFormat

Returns/Sets whether the date format used in the report should also be used in the exported report. Can be used for Data Interchange Format (DIF), Record Style Format, and comma, tab, or character separated format.

Read/Write

UseReportNumber
Format

Returns/Sets whether the number format used in the report should also be used in the exported report. Can be used for Data Interchange Format (DIF), Record Style Format, and comma, tab, or character separated format.

Read/Write



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com